[dbo].[BAECompanyContactLoginValidation]

SQLServer > iMIS1521GA > Stored Procedures > dbo.BAECompanyContactLoginValidation

Property	Value
ANSI Nulls On
Quoted Identifier On

Name	Data Type	Max Length (Bytes)
@UserID	varchar(10)	10

CREATE PROCEDURE [dbo].[BAECompanyContactLoginValidation]
      @UserID as varchar(10)
AS
      /* General Notes:
            Ideally, you would want this procedure to only return one row in order to maximize efficiency.
            Regardless of how it determines who has access, it absolutely must return the ID field from the
            iMIS Name table in some fashion.
      */
      SELECT ID FROM Name WHERE MEMBER_TYPE IN('CM') AND CO_ID <> '' AND ID = @UserID;

GO